Hi all, see attached worksheet as an example. I need to combine two IF Functions that work separately just fine, but I cannot seem to get them combined.
FORMULA #1 (Already in place) =IFERROR(IF(F3>390,"-",G3/D3),"-")
I need to add this one before it to meet different criteria =IF(OR(B3="Sat",B3="Sun",B3="Holiday"),G3/D3, Insert formula #1)
Thanks for any help
Last edited by Alphabex; 07-15-2016 at 07:24 PM.
Hi,
Like this in I3 and pull down?
=IF(OR(B3="Sat",B3="Sun",B3="Holiday"),G3/D3,IFERROR(IF(F4>390,"-",G4/D4),"-"))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
YES!!! I had to mover the IFERROR to the front to get rid of the outliers, but Yes this worked!!! Thank you so much
Try this ...
=IFERROR(IF(OR(B3={"Sat","Sun","Holiday"},F3<=390),G3/D3,"-"),"-")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks