Folmula

[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

 

[Ken Wright]

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???"))

 

[Frank Kabel]

See the replies in the 'newusers' group
Frank

 

[Don Guillett]

Answered properly elsewhere. You need not post in multiple groups.