Hi,
a different approach could be a formula in M2 to be copied down
=F2*IF(I2="YES",0.5,1)
Hope it helps
Hi,
a different approach could be a formula in M2 to be copied down
=F2*IF(I2="YES",0.5,1)
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks