LinkBack URL
About LinkBacks
Hi All,
I have the following formula that is giving me the data that I want:
=IFERROR(Q55/VLOOKUP(C55,'Box Formula'!A41:E5357,2,FALSE),"")
However, I want to include something that says if E55="PLANNING" then make W55=0
Can anyone help?
Hi All,
I have the following formula that is giving me the data that I want:
=IFERROR(Q55/VLOOKUP(C55,'Box Formula'!A41:E5357,2,FALSE),"")
However, I want to include something that says if E55="PLANNING" then make W55=0
Can anyone help?
Is the formula =IFERROR(Q55/VLOOKUP(C55,'Box Formula'!A41:E5357,2,FALSE),"") in W55?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks