Formula needed

[Tammy]

Help! I'm trying to figure out a formula that will enter a
$ amount in one cell depending on what other cell is
marked.

Example - If r1c3 has an x in it then r1c17 would show
$97.50 but if r1c5 has the x then r1c17 would show $135.00.

Can this be done? If so please let me know what formula I
should use.

Thanks,
Tammy

 

[Bob Phillips]

=IF(C1="x",97.5,IF(Q1="x",135,""))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)