I gave you an example.
=IF(Z1<1000,"Need cash !!!", "OK")
=IF(test......., true-value.......,false-value)
The syntax
=IF(condition to test, what you what when test is true, what you want when
test is false)
You will learn a great deal if you type in my example; change what is in Z1
watch what happens
Change "Need Cash" to "Holy cow!", etc
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bill" wrote in message
...
Bernard:
Thank you. However, can you please provide me with the proper syntax
for a conditional formula. I believe there is something thnat states if x,
then y and converts to some value.

Regards,

Bill
--
wcc


"Bernard Liengme" wrote:

Be careful!
If Z1 hold the CASH value
And $1000 (or 1000SF or £1000) is the alarum value
Then, in an empty cell type
=IF(Z1<1000,"Need cash !!!", "OK")
Play with this on a new unimportant workbook
You should be able to see how to customize it to fit your needs
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Bill" wrote in message
...
I have an extensive financial model, but need to add a feature for
insuring
cash remains above a certain value. What I want to do is express a
formula
that states that if cash falls below a specific value, then funds are
transferred from a line of credit. I know this is a conditional
formula,
but
I am obviously not experienced enough to create the proper formulas.
--
wcc