View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Holly
 
Posts: n/a
Default IF statement help

A B C
8 2 1

In column C I have the following
=IF(A27,1,IF(A2=6,2,IF(A2=3,3,IF(A2=1,4,5))))
which is working for me however I would like this formula to also perform
the following.
If cell B2 0 i want it to subtract 1 from the result
(the actual number in C should be a zero)

Is this possible?