Folmula

  • Thread starter Thread starter dozzy36
  • Start date Start date
D

dozzy36

I need to write a folmula to do the following:
if D2=Y then multiply B2*.18, if D2=N then do nothing,
can anyone tell me how this should be written
 
IF those are the only two possible options then you only need to trap for one,
eg:-

=IF(D2="Y",B2*18,"")

But if there are more options than just Y/N:-

=IF(D2="Y",B2*18,IF(D2="N","","What now???"))
 
Back
Top