IF formula

[ashj723]

I'm trying to insert a cell number for the >= value rather than an actual number.. is this possible and if so whats the proper formula??

If F minus D is > F then “BooK Price”

This is the formula i've typed.... but its not working obviously..

=IF((F1-D1)>=F1,"Book Price","Below Book"))

[arthurbr]

Hi and welcome to the board

You will have to be a little more explicit, obviously F1-D1>=F1 will only work if D1 is negative or =0

Of course F1-D1 >=another_cell_content is also possible