Is there a function or a way to tell excel to return a specific string if a value is say plus or minus 5.
For example:
IF(OR(K9=K35,K9=""),"ESTIMATE","ACTUALS")
I need it to say if K9 is equal to K35 plus or minus 5.
Thanks.
ep
Is there a function or a way to tell excel to return a specific string if a value is say plus or minus 5.
For example:
IF(OR(K9=K35,K9=""),"ESTIMATE","ACTUALS")
I need it to say if K9 is equal to K35 plus or minus 5.
Thanks.
ep
=IF(ABS(k9-k35)<5,true response,false response)
Regards
Dav
Thanks Dav, worked great.
IF(OR(ABS(K9-K35)<5,K35=""),"ESTIMATE","ACTUALS")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks