Formula needed

  • Thread starter Thread starter Auntie Annette House MO
  • Start date Start date
A

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
 
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
 
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
 
Back
Top