Hi,
Please see the attached, Trying to write a formula with a lot of conditions and I am stuck.
Please Advise. -Your feedback is greatly appreciated.
Hi,
Please see the attached, Trying to write a formula with a lot of conditions and I am stuck.
Please Advise. -Your feedback is greatly appreciated.
Try this...
=IF(F1=0,IF(B1="a",D1,A1),H1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try
=IF(F1=0,IF(B1="A",D1,A1),G1)
Jason, thanks for teh post, it made me see I had my last reference wrong
=IF(F1=0,IF(B1="a",D1,A1),G1)
Try ..
=IF(F1<>0,G1,IF(AND(F1=0,B1<>"A"),B1,IF(AND(F1=0,B1="A"),D1,"")))
Thank You guys for your responses!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks