2016-06-07_10-57-50.png
I need something like =G2*.2 UNLESS H2=Yes THEN 0
2016-06-07_10-57-50.png
I need something like =G2*.2 UNLESS H2=Yes THEN 0
Try
=IF(H2="Yes",0,G2*0.2)
Or
=G2*0.2*(H2<>"Yes")
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks