Thread: If statement; How to do something similar to - if(a1-a2=5,+5)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default If statement; How to do something similar to - if(a1-a2=5,+5)

=IF(A1+B1=5,.05,0)
or maybe you are looking for something like. You didn't say
=a2+IF(A1+B1=5,.05,0)
=123+IF(A1+B1=5,.05,0)

Don Guillett
SalesAid Software

"Magoo" wrote in message
oups.com...
If Sum of two cells is Greater than or equal to 5 then +0.5 If not
then normal sum.


Reply With QuoteReply With Quote