You have entered too few arguments for this function

-

I was just wondering if there is a way that I can solve this formula so I dont keep getting errors, if there is a way khổng lồ simplify it too that would be a massive help.

Bạn đang xem: You have entered too few arguments for this function

=IFS((OR(G5TODAY()+30,"YES", H5TODAY()+30,"YES", I5TODAY()+30,"YES")))

Im trying to get a separate cell khổng lồ change if any one of the cells in the formula above becomes expired or nearing its expiration.

Thank you for any help!

Gajm


*

Mod
*
· 2 yr. ago · Stickied commentLocked
/u/Gajm10 - please read this bình luận in its entirety.

Once your problem is solved, please reply to the answer(s) saying Solution Verified to lớn cđại bại the thread.

Please ensure you have read the rules -- particularly 1 & 2 -- in order to lớn ensure your post is not removed.

I am a bot, và this action was performed automatically. Please tương tác the moderators of this subnaruto2016.vn if you have any questions or concerns.


Try và bởi this stepwise in seperate cells & see where you have the error. When all works, you can build them together in same cell.

Xem thêm: Người Yêu Ơi Bao Đêm A Thầm Mơ Bóng Em Đến, Lời Bài Hát Còn Lại Một Mình


On their own the formula works, however when I put it all together, it seems that the formula only takes note of the first lot of cells (in this case cells "G") if you have any idea as khổng lồ why this is or how lớn possibly solve sầu it, that would be very helpful.

Thank you


Acronyms, initialisms, abbreviations, contractions, and other phrases which exp& khổng lồ something larger, that I've sầu seen in this thread:

Fewer LettersMore Letters
IFSpecifies a logical test to lớn perform
IFSChecks whether one or more conditions are met và returns a value that corresponds to the first TRUE condition.
MAXReturns the maximum value in a list of arguments
MINReturns the minimum value in a các mục of arguments
ORReturns TRUE if any argument is TRUE
TODAYReturns the serial number of today's date
VLOOKUPLooks in the first column of an array và moves across the row to lớn return the value of a cell

7 acronyms in this thread; the most compressed thread commented on today has 18 acronyms. ^


To reduce the number of comparisons, can you use MIN(G2:H2)TODAY()+30?

Also, could you make a table of the limit boundaries and use an approximate match VLOOKUP khổng lồ pull the appropriate label back?


Thank you for your reply,

Unfortunately I am very new to lớn excel so ill have lớn look into that before I can try implementing it inkhổng lồ my spreadsheet.

Thanks again


The last argument for an IFS statement must be the result if FALSE.

=IFS(condition_1, result_if_true_1, condition_2, result_if_true_2,..., result_if_false)

=IFS(G5TODAY()+30,"YES", H5TODAY()+30,"YES", I5TODAY()+30,"YES","RESULT IF FALSE")
Actually this is incorrect. See the link from Decronym elsewhere in this thread. For a mặc định value, you'd have to lớn haông xã it by preceding your final argument with TRUE.


Thank you for the reply,

I've sầu tried this formula however it is still returning the same error message, any other suggestions would be great!

Thank you


Thank you for the reply,

I've tried this formula however it is still returning the same error message, any other suggestions would be great!