Formula needed

[Auntie Annette House MO]

How do I make a formula that will say this for me?
If D18 is greater than 0 then multiply D18 by $5.00 and subtract from
L35.
Annette

 

[JulieD]

Hi Annette

=IF(D18>0,L35-D18*5,0)
you didn't say what you wanted to do if D18 was less than or equal to zero,
so i added the false parameter (the third one above), i.e. the 0 in.

Cheers
JulieD

 

[JE McGimpsey]

One way:

=IF(D18>0,L35-5*D18,"")

 

[Auntie Annette House MO]

I want to thank you so much. It works perfectly. I am so green at excell
formulas. I am great with Word and plain data base but that is all Again
thanks.

--
"I am too blessed to be stressed or depressed, and too anointed to be
disappointed!"

The shortest distance between a problem and a solution is the distance
between your knees and the floor.

"The one who kneels to God can stand up to anything."

"Winners make things happen. Losers let things happen."

"God grant me the serenity to accept the people I cannot change, the
courage to change the 'ONE' I can change, and the wisdom to know that it's
ME