Hi
I have this formula which produces an estimated purchase price from a selling price...
=(F4-3.95-((F4-3.95)*0.2))
I need this to operate only when F4 is filled, otherwise I get a minus figure for a sale that hasn't happened.
Eventually the result figure will be replaced by an actual figure, so is there also is there a way I can force this estimated result to show in red?
Thanks
Try it like this
=IF(F4="","",(F4-3.95-((F4-3.95)*0.2)))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
6 minutes to fix my problem, nice job Alkey TY
Is there anything I can do on the colour thing?
LOL. Actually it only took 10 secOriginally Posted by Ziggy21
For the colour: I suppose you can use Conditional formatting with a simple formula: A1<0
where A1 is the cell with the formula.
Last edited by AlKey; 02-25-2015 at 11:26 AM. Reason: Corrected formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks