Hi,
I tried to amend a formula to add an additional rule but I must have it wrong as it's not returning the value I expect.
This is the original formula which works fine:
=IF(AC5>45,"",IF(AC5>29,"Must",IF(AC5>19,"Should",IF(AC5>9,"Could",IF(AC5>=0,"Will Not")))))
This is the amended formula:
=IF(AC4>45,"",IF(AC4>29,"Must",IF(AC4>19,"Should",IF(AC4>9,"Could",IF(AC4>=0,"Will Not",IF(AC4=Legal or Fiscal,"Must"))))))
Thank you
Undeterminable as you haven't explained what you're trying to achieve.
But you either want this
=IF(AC4 > 45,"",IF(AC4 > 29,"Must",IF(AC4 > 19,"Should",IF(AC4 > 9,"Could",IF(AC4 > =0,"Will Not",IF(AC4="Legal or Fiscal","Must","OTHER"))))))
or this
=IF(AC4 > 45,"",IF(AC4 > 29,"Must",IF(AC4 > 19,"Should",IF(AC4 > 9,"Could",IF(AC4 > =0,"Will Not",IF(OR(AC4="Legal",AC4="Fiscal"),"Must","OTHER"))))))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi,
Perhaps you've forgot to hard-code the text with ""
try:
=IF(AC5>45,"",IF(AC5>29,"Must",IF(AC5>19,"Should",IF(AC5>9,"Could",IF(AC5>=0,"Will Not",IF(AC5="Legal or Fiscal","Must"))))))
or this if legal or fiscal are separate:
=IF(AC5>45,"",IF(AC5>29,"Must",IF(AC5>19,"Should",IF(AC5>9,"Could",IF(AC5>=0,"Will Not",IF(OR(AC5={"Legal","Fiscal"}),"Must"))))))
Moreover, I suggest to make a lookup table instead of nesting IFs.
Blessing.
Khalid
Didn't noticed Special-K already replied
Thank you both for taking the time to reply. This is perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks