Hi,
I need to use an IF formula to populate a value if A2 is 72% less than A1. I can't figure out how to specify a particular percentage difference.
Can anyone help?
Hi,
I need to use an IF formula to populate a value if A2 is 72% less than A1. I can't figure out how to specify a particular percentage difference.
Can anyone help?
=if(a2<0.72*a1,"Hello","Goodbye")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks